select statement

Remaster the replicate definition and modify the replicate SELECT statement to replicate data for the newly-added column.

remaster复制定义，修改复制SELECT语句，以便为新添加的列复制数据。

互联网摘选

The fields of the array are named fields that map to the upper case column names that were requested in the SELECT statement.

该数组的字段是命名字段，用于映射SELECT语句中需要的大写体列名。

互联网摘选

For example, based on the customerID field of the event, the address field is computed using a SELECT statement against a database table.

例如，基于事件的customerID字段，针对数据库表使用SELECT语句来计算地址字段。

互联网摘选

To verify that the update is successful, launched the DB2 command line window and issue a SELECT statement.

为了验证更新成功，需要启动DB2命令行窗口，并发出SELECT语句。

互联网摘选

In the configure select statement step of the configure data source wizard, you can click advanced to display advanced options where you can have the wizard generate update queries.

在“数据源配置向导”的“配置select语句”步骤中，可以单击“高级”显示高级选项，在高级选项中可使向导生成更新查询。

provided by jukuu

It should be noted that there are situations where the FOR UPDATE clause is not available for a given SELECT statement.

需要注意的是，在某些情况下给定的SELECT语句不能使用FOR UPDATE子句。

互联网摘选

You insert four rows into the database and issue a SELECT statement to verify that the new table contains four rows.

您将四行插入数据库中，然后执行SELECT语句以验证新表包含四行。

互联网摘选

In this case, they can issue a SELECT statement to identify rows that qualify then DELETE those rows.

在这种情况下，他们可以发出一条SELECT语句来识别符合条件的行，然后再DELETE那些行。

互联网摘选

Creates a shadow replicate using the attributes of the existing mastered replicate attributes, with the new master dictionary, and the new SELECT statement.

使用已有的主复制属性，加上新的主目录和新的SELECT语句，创建一个影子复制。

互联网摘选

The cdr remaster command accepts only one SELECT statement.

cdr remaster命令只接受一个SELECT语句。

互联网摘选

Click next to advance to the configure the select statement page of the wizard.

单击“下一步”以前进到向导的“配置select语句”页。

provided by jukuu

Auto remastering ( cdr remaster command) only works when the replicate SELECT statement column names and table names match across all the replicate participants

自动remastering（cdr remaster命令）只有在复制SELECT语句中的列名和表名所有复制参与者匹配时才适用

互联网摘选

Invoking the HISTORY command again shows that there are now five commands or statements in the cache, including the modified SELECT statement.

再次调用HISTORY命令来显示缓存中现在有5个命令，包括修改的SELECT语句。

互联网摘选

The second performs a select statement, using the alternative question mark placeholders.

而第二个例子使用问号占位符执行一条select语句。

互联网摘选

Unlike indexes, materialized views can be accessed directly using a SELECT statement.

不同于索引, 物化视图可以使用SELECT语句直接访问.

互联网摘选

The point, however, is that the VALUES INTO statement that saves away the error-variables is nearly as expensive as the SELECT INTO statement.

然而，问题是用于保存错误变量的VALUES INTO语句的花费几乎与SELECT INTO语句的一样高。

互联网摘选

This second select statement is joined with the Common Table Expression ( CTE) itself by linking parent to child data.

第二个SELECT语句通过将父数据链接至子数据与公共表表达式（CTE）联接。

互联网摘选